package com.nanyang.tms.mq.listener.importforecast;

import java.io.Serializable;
import java.math.BigDecimal;

import com.alibaba.excel.annotation.ExcelProperty;

import lombok.EqualsAndHashCode;
import lombok.Getter;
import lombok.Setter;
@Getter
@Setter
@EqualsAndHashCode
public class ForecastExcelDTO implements Serializable{
	private static final long serialVersionUID = 1L;
	@ExcelProperty(index=0,value="客户订单号")
	private String customerNo;  //客户订单号
	@ExcelProperty(index=1,value="目的地中文名")
	private String countyCode;  //国家编号
	@ExcelProperty(index=2,value="销售产品")
	private String saleProductCode; //产品编码
	@ExcelProperty(index=3,value="快递货物类型编码")
	private String cargoTypeCode; //货物类型  ：袋子 文件 包裹
	@ExcelProperty(index=4,value="快递货物类型")
	private String cargoTypeName; //货物类型  ：袋子 文件 包裹
	@ExcelProperty(index=5,value="SKU1")
	private String sku1;
	@ExcelProperty(index=6,value="产品中文名称1")
	private String nameEn1;
	@ExcelProperty(index=7,value="产品英文名称1")
	private String nameCn1;
	@ExcelProperty(index=8,value="海关货物编号1")
    private String customsNo1;
	@ExcelProperty(index=9,value="申报数量1")
    private Integer quantity1;
	@ExcelProperty(index=10,value="申报单位1")
    private String unitCode1;
	@ExcelProperty(index=11,value="申报单价1")
	 private BigDecimal price1;
	@ExcelProperty(index=12,value="申报价值1")
    private BigDecimal totalPrice1;
	@ExcelProperty(index=13,value="申报重量1")
    private BigDecimal declareWeight1;
    
	@ExcelProperty(index=14,value="SKU2")
	private String sku2;
	@ExcelProperty(index=15,value="产品中文名称2")
    private String nameEn2;
	@ExcelProperty(index=16,value="产品英文名称2")
    private String nameCn2;
	@ExcelProperty(index=17,value="海关货物编号2")
    private String customsNo2;
	@ExcelProperty(index=18,value="申报数量2")
    private Integer quantity2;
	@ExcelProperty(index=19,value="申报单位2")
    private String unitCode2;
	@ExcelProperty(index=20,value="申报单价2")
    private BigDecimal price2;
	@ExcelProperty(index=21,value="申报价值2")
    private BigDecimal totalPrice2;
	@ExcelProperty(index=22,value="申报重量2")
    private BigDecimal declareWeight2;
	
	@ExcelProperty(index=23,value="SKU3")
	private String sku3;
	@ExcelProperty(index=24,value="产品中文名称3")
    private String nameEn3;
	@ExcelProperty(index=25,value="产品英文名称3")
    private String nameCn3;
	@ExcelProperty(index=26,value="海关货物编号3")
    private String customsNo3;
	@ExcelProperty(index=27,value="申报数量3")
    private Integer quantity3;
	@ExcelProperty(index=28,value="申报单位3")
	private String unitCode3;
	@ExcelProperty(index=29,value="申报单价3")
	 private BigDecimal price3;
    @ExcelProperty(index=30,value="申报价值3")
    private BigDecimal totalPrice3;
    @ExcelProperty(index=31,value="申报重量3")
    private BigDecimal declareWeight3;
	@ExcelProperty(index=32,value="客户订单重量")
	private BigDecimal customerWeight;  //重量
	@ExcelProperty(index=33,value="发件人名称")
	private String senderName;
	@ExcelProperty(index=34,value="发件人公司名称")
    private String senderCompanyName;
	@ExcelProperty(index=35,value="发件人国家")
    private String senderCountyCode;
	@ExcelProperty(index=36,value="收件人名称")
	private String recipientName;
	@ExcelProperty(index=37,value="收件人公司")
    private String recipientCompanyName;
	@ExcelProperty(index=38,value="收件人电话")
    private String mobile;
	@ExcelProperty(index=39,value="收件人邮箱")
    private String email;
	@ExcelProperty(index=40,value="收件人省(州)")
    private String provinceCode;
	@ExcelProperty(index=41,value="收件人城市")
    private String city ;
	@ExcelProperty(index=42,value="收件人邮编")
    private String zipCode;
	@ExcelProperty(index=43,value="收件人地址")
    private String address;
	@ExcelProperty(index=44,value="实重")
    private BigDecimal weight;
	@ExcelProperty(index=45,value="长")
    private BigDecimal length;
	@ExcelProperty(index=46,value="宽")
    private BigDecimal width;
	@ExcelProperty(index=47,value="高")
    private BigDecimal height;
	@ExcelProperty(index=48,value="订单备注")
	private String remark; //备注
    private Integer num=1;
}
